Miscellaneous Corrections and Additions to the Wingz Documentation
• Wingz 1.1 files cannot be read by Wingz 1.0.
• Changes were made in version 1.1 to improve the accuracy and quality of your printed output. These changes may affect what is displayed in Page Preview.
• An additional file structure can now be imported to Wingz. This new feature allows you to directly read BIFF worksheet files such as those created by Excel. For additional information on this new capability, see the BIFF READ ME file found on the HELP AND EXAMPLES disk.
• To install the Apple® Color Picker, perform the following steps:
1. Put the external Wingz file "colpick" in your Wingz folder. (This file is located in the Color Picker folder within the Utilities folder on the Help and Examples disk.)
2. Create a script containing the line:
GET EXTERNAL "colpick"
3. Save the script as "Startup" in your Wingz folder. (If a script named "Startup" already
exists in your Wingz folder, add the line GET EXTERNAL "colpick" to your existing script.)
4. Quit Wingz and then relaunch Wingz.
• NOTE: When an Excel file that is using a number format that contains commas is saved to a WK1 (Lotus 1-2-3®) format, the commas in the numbers are not saved.
• A 72 dots per inch (dpi) print resolution setting results in your printed output most closely matching the appearance of your screen. If you are using a higher resolution setting and you are not obtaining the printed results desired, use the Page Setup command in the File menu to switch to a 72 dpi setting.
• A file named Startup, located in the Examples folder on the Help and Examples disk, can be used to add four new commands to the Sheet menu that, when executed, demonstrate a few of the capabilities of HyperScript. If you already have a file called Startup in your Wingz folder, copy the text of this Startup script into your existing Startup script file.
Corrections and Additions to the Wingz User's Guide
• Page 47. The second sentence of the fourth instructional step (indicated by the fourth red box on the page) should be changed to read:
Begin in the current cell (B5) and move to the right by accepting each entry with the tab key.
• Page 86. The following Cell Border command option should be included after the third paragraph on the page:
Top. Choose Top to place a border on the top edge of every cell in the selected range.
• Page 99. The second sentence of the second paragraph should be changed to read:
For example, the picture string 0.00;; prevents the display of negative and zero values.
Corrections and Additions to the Wingz Reference Manual
• Page 23. The following note should appear after the paragraph entitled Right Margin:
NOTE: If a reduction is defined in Page Setup, the margin values that have been defined will also be increased or decreased in proportion to the reduction value.
• Page 27. The following sentence should be added to the end of the first paragraph in the section entitled Undo/Redo:
The Undo command is not available when text has been cut, pasted, or cleared from a text field or script.
• Page 55. In Table 5-1, the Custom Format column should be changed to read as follows:
"Region" @
@ "Expense"
"Item" @ "is out of stock."
• Page 75. The following note should be inserted in the Sheet Info section after the paragraph that is entitled Name:
IMPORTANT: To ensure the integrity of your Auto Save backup files, if you have multiple worksheets open and Auto Save is activated for each worksheet, or if you are using Auto Save in a network environment, assign a unique Auto Save file name for each of your worksheets.
• Page 162. The last sentence in the paragraph entitled Series Label Range should be deleted and replaced with the following sentence:
Labels that are added using the Series Label Range command must be written contiguously in the selected range for all chart types.
• Page 227. The second paragraph of the BORDERBG() function description should be changed to read:
The HyperScript command SHADOW BG number sets the drop shadow background color for the selected objects.
• Page 227. The second paragraph of the BORDERFG() function description should be changed to read:
The HyperScript command SHADOW FG number sets the drop shadow foreground color for the selected objects.
• Page 255. The last sentence in the description of the FACTORIAL function should be deleted and replaced with the following sentence:
Negative values do not have a defined mathematical factorial; "ERR12" is returned when a negative argument is used for this function.
• Page 272. The second example in the LEFT function description should be changed to read:
LEFT(A1,8) returns "Region A" when A1 contains "Region A"
• Page 303. The second paragraph of the SHADOWBG() function description should be changed to read:
The HyperScript command 3D CHART SHADOW BG number sets the background color of the shadow for the selected 3D chart.
• Page 303. The second paragraph of the SHADOWFG() function description should be changed to read:
The HyperScript command 3D CHART SHADOW FG number sets the foreground color of the shadow for the selected 3D chart.
• Page 314. The last three BITAND functions at the top of the page should be changed to read:
BITAND (SURFDISP(), 8) 0 Pedestal is not visible
BITAND (SURFDISP(), 16) 16 Manual offset defined for base
BITAND (SURFDISP(), 16) 0 Offset for base determined automatically
• Page 362. The second sentence in the first paragraph of the section entitled Footer should be changed to read:
If you embed &p in the footer text, the current page number is printed in the footer on each page.
Corrections and Additions to the Wingz HyperScript Manual
• Page 19. The second sentence of the second example on the page should be changed to read:
SELECT RANGE B1..B5
• Page 46. The second example at the bottom of the page should read as follows:
LINE SPACING FIXED .05 inches
• Page 49. The first sentence in the first paragraph on the page should be changed to read:
In the example above, a random number between 0 and 20 is placed in cell A1 and the value of the number is compared to 10.
• Page 54. In Table 3-3, the second 13 in the Pass column should be changed to 14 and the second 25 in the Pass column should be changed to 26.
• Page 61. The second sentence of the first paragraph under the section entitled Selecting Cells in a Worksheet should read:
The GO TO CELL, SELECT RANGE, and SELECT MORE RANGE HyperScript commands can be used to select specific cells in a worksheet.
• Page 62. The heading for the first paragraph should be changed to read:
SELECT MORE RANGE range.
• Page 79. The first sentence on the page should be changed to read:
The FORMAT function returns the numeric format value of the selected cell.
• Page 79. Starting with the first Example on the page, delete all the remaining text and replace it with the following:
Example:
DEFINE number,format
number = NFORMAT(23456, 128)
PUT number INTO D1
SELECT RANGE D2
PRECISION 0
SELECT RANGE D1
format = FORMAT()
PUT format INTO D2
In the next example, the number placed into cell E1 is 23456. It is then formatted as currency, with parentheses, commas, and a decimal precision of two. The result of the FORMAT() function, 802, is placed in cell E2. This result is the sum of the formats used: currency (32), parentheses (256), commas (512), and the precision (2).
Example:
PUT 23456 INTO E1
SELECT RANGE E1
FORMAT CURRENCY
USE PARENTHESIS
USE COMMAS
PRECISION 2
PUT FORMAT() INTO E2
• Page 80. Add the following statement as the first line of the first Example on the page:
SELECT RANGE A1
• Page 88. In the second sentence in the last paragraph on the page, the cell coordinate for X_left should be changed from 149 to 55.
• Page 106. In the Example at the bottom of the page, the second statement should read as follows:
MANUAL SCALING FROM 300 to 400 WITH 10 MAJOR AND 2 MINOR DIVISIONS
• Page 110. In the group of examples in the middle of the page, the second line should read as follows:
AXIS MAJOR GRID WIDTH .05 inches
• Page 110. In the group of examples in the middle of the page, the sixth line should read as follows:
AXIS MINOR GRID WIDTH .05 inches
• Page 114. In the Example at the bottom of the page, the worksheet range used in the first statement should be changed from A1..D4 to A1..E5.
• Page 115. In the first Example on the page, the worksheet range used in the first statement should be changed from A1..D4 to A1..E5.
• Page 127. The last line of the examples at the bottom of the page should read as follows:
SYMBOL SIZE .25 inches
• Page 129. In Table 5-8, the values returned should be 1, 2, 3, and 4, not 0, 1, 2, and 3.
• Page 139. In the Example on the page, the fourth statement should read:
ELSEIF PERSPECTIVE() > 200 AND PERSPECTIVE() < 399
• Page 152. The second sentence on the page should be changed to read:
If 4 (TRUE) is returned, the axes display in on; if 0 (FALSE) is returned, the axes display is off.
• Page 165. The second and third paragraphs on the page should be replaced with the following:
The HyperScript functions BORDERFG(), BORDERBG(), and BORDERPATTERN() can be used to return the current value of the shadow attributes for a selected object.
The BORDERFG() and BORDERBG() functions return the RGB color value of the selected object's shadow. BORDERPATTERN() returns the object pattern number 0 through 38.
• Page 187. In the second Example on the page, the first statement should be replaced with:
ADD FIELD RANGE B3..C12
• Page 189. The last result in the CTSTRING() table in the middle of the page should be changed from 20 to 21.
• Page 192. In the last group of examples on the page, the third line should read as follows:
NUMBER WHEEL STEP .001
• Page 196. In the second Example on the page, the first statement should be changed to read:
ADD SCROLL BAR RANGE FRAC(C7..C13,1,100,128,159)
• Page 232. The RESULT column of the CTVALUE() Example should read: 40, 40, 40, and 40.
• Page 235. The RESULT column of the CTVALUE() Example should read: 1, 0, 1, 0, and 0.
• Page 241. The RESULT column of the CTVALUE() Example should read: 1, 0, 1, 0, and 0.
• Page 242. The tenth statement in the Example should read:
REPAINT RANGE A1..E20
• Page 265. The fifth statement in the Example should read:
DIALOG DEFAULT PUSH BUTTON
• Page 271. The fifth statement in the Example should read:
ADD OVAL RANGE A1..A6
• Page 289. The first sentence on the page should read:
The number of menus to be contained in the menu bar can be specified using the ADD MENUBAR string WITH number MENUS command.
• Page 293. All of the occurrences of the word "Harpsicord" on this page should be changed to "Harpsichord."
• Page 300. In the first sentence under the Square Windows section, the coordinates of the SQUARE WINDOW command should be changed to: SQUARE WINDOW (Xmin,Ymin) (Xmax,Ymax).
• Page 311. The following statements should be added to the beginning of the Example:
REPAINT OBJECT1
ON REPAINT
• Page 311. The following statement should be added to the end of the Example:
END REPAINT
• Page 316. The syntax for the DRAW ARC command should be changed to read:
DRAW ARC (Xmin,Ymin) (Xmax,Ymax) Start_angle FOR Delta_angle
• Page 335. The last line in the example (pret->err = 12;) should be deleted and replaced with the following line:
pret->val.err = 12;
• Page 336. In the first example on the page, the third line from the bottom of the example (pret^.err : = 12;) should be deleted and replaced with the following line:
pret^.val.err : = 12;
• Page 336. The second sentence in the first paragraph in the section entitled Compiling and Linking should be deleted and replaced with the following sentence:
For example, in MPW "C" you would compile MyMath by entering C MyMath.c -o MyMath.c.o.
• Page 339. The last statement before the PROUT main() statement (pret->err = 12;) should be deleted and replaced with the following statement:
pret->val.err = 12;
• Page 347. The following command and description should be added to the section entitled Copy.
COPY FROM range1 TO range2
This command copies the cell information from the cell location designated by range1 to the location designated by range2. All formatting is retained when the cell information is copied and all relative references in formulas are modified to reflect the new location. This command replaces the following sequence of commands:
SELECT RANGE range1
COPY
SELECT RANGE range2
PASTE
• Page 364. In Table 12-3, the second notation signifying minute should be changed from "mn" to "mm".
• Page 398. The last sentence on the page should read as follows:
The base placement percent limit is 255.
• Page 407. The following sentence should be added to the description of the RUN command:
A maximum of 255 characters can be specified for the string.
• Page 417. The following note should be added above Figure 12-6:
NOTE: If an insufficient amount of space is available to redraw the selected arc when the ARC ANGLE command is executed, no change is made to the object.
• Page 432. The last sentence in the second paragraph should be deleted and replaced with the following sentences:
The control name is displayed to the left of the control, followed by a colon. To suppress the display of the newly defined control name, use the HIDE CONTROL NAME command.
• Page 493. The following error message and description should be added between error 0006 and error 0008:
0007 Reference error
A dependent cell was removed from the worksheet using the Delete command in the Edit menu. The formula cannot be calculated because of the missing cell.
